home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 7 / developer source - volume 7.iso / dbmsa / dec96 / kimbf101.gif < prev    next >
Graphics Interchange Format  |  1997-04-17  |  43KB  |  339x340  |  4-bit (16 colors)
Labels: text | screenshot | font
OCR: invoice Line Item Fact Table Time dimension Time_key Customer_key Customer dimension Product dimension Product key Promotion key Promotion dimension Shipper dimension Shipper key Status_ key Status dimension Invoice Number Units Dollars Before Discount Discount Dollars After Discount Dollar Cost Figure 1. A Customer Invoices Data Mart. Each record in this fact table represents an invoice line item. The Invoice Number is a "degen- erate" dimension that allows line items on a particular invoice to be grouped.